﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/


/*EUROPEAN MARKETS*/
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'VSE','Wiener Börse','AUSTRIA','9:00:00','9:02:00','22:30:00','22:35:00');  
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'CHIXEN','Chi-X','EUROPE','9:00:00','9:02:00','17:40:00','17:40:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'NUROEN','NASDAQ OMX','EUROPE','7:50:00','7:50:00','17:00:00','17:00:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'TRQXDE','TURQUOISE','EUROPE','9:00:00','9:00:00','17:30:00','17:30:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'BELFOX','Euronext BG Stocks','BELGIUM','9:00:00','9:02:00','17:40:00','17:40:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SBVM','Euronext BG Stocks','BELGIUM','9:00:00','9:02:00','17:40:00','17:40:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SBF','Euronext FR Stocks','FRANCE','9:00:00','9:02:00','17:30:00','17:35:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'MONEP','Euronext FR Derivatives','FRANCE','8:00:00','8:00:00','22:00:00','22:00:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'MATIF','Euronext FR Commodities','FRANCE','8:00:00','9:02:00','22:00:00','22:35:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'DTB','Eurex','GERMANY','8:00:00','8:00:00','22:10:00','22:10:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'IBIS','XETRA','GERMANY','9:00:00','9:00:00','17:30:00','17:30:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'FWS','FrankFurt Stock Exchange','GERMANY','9:00:00','9:00:00','20:00:00','20:00:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SWB','Stuttgart Stock Exchange','GERMANY','9:00:00','9:00:00','20:00:00','20:00:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'IDEM','Borsa Italiana','ITALY','9:00:00','9:02:00','17:40:00','17:40:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'AEB','Euronext NL Stocks','NETHERLAND','9:00:00','9:02:00','17:30:00','17:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'FTA','Euronext NL Derivatives','NETHERLAND','9:00:00','9:02:00','17:30:00','17:35:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'MSE','Madrid Stock Exchange','SPAIN','9:00:00','9:02:00','17:30:00','17:30:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'MEFF','Barcelona Stock Exchange','SPAIN','9:00:00','9:02:00','17:30:00','17:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SFB','Stockholm Stock Exchange','SWEDEN','9:00:00','9:02:00','17:30:00','17:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'OMX','Stockholm Derivatives Exchange','SWEDEN','9:00:00','9:02:00','17:30:00','17:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SWX','Swiss Stock Exchange','SWISS','9:00:00','9:02:00','17:30:00','17:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'VIRTX','Virt-X','SWISS','9:00:00','9:02:00','17:30:00','17:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SOFFEX','Swiss Options and Financial Futures Exchange(Eurex)','SWISS','9:00:00','9:02:00','17:20:00','17:20:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'ICE/IPE','Intercontinental Exchange','UK','3:00:00','3:00:00','23:00:00','23:00:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'LIFFE NF','LIFFE Commodities','UK','3:00:00','3:00:00','23:00:00','23:00:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'LSSF','LIFFE Single Stock Future','UK','9:00:00','9:02:00','18:30:00','18:30:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'LIFFE','LIFFE Options & Futures','UK','9:00:00','9:02:00','18:30:00','18:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'LSE','London Stock Exchange','UK','9:00:00','9:02:00','18:30:00','18:30:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'IDEALPRO','IDEALPRO','WORLDWIDE','23:15:00','23:15:00','23:00:00','23:00:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'SMART','SMART Order Routing','WORLDWIDE','09:00:00','09:00:00','20:00:00','20:00:00'); 

/*US MARKETS*/
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'NYSE','New York Stock Exchange','USA','9:00:00','9:02:00','22:30:00','22:35:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'CBOE','Chicago Board Options Exchange','USA','9:00:00','9:02:00','22:30:00','22:35:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'CME','Chicago Mercantile Exchange','USA','9:00:00','9:02:00','22:30:00','22:35:00');
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'ASE','American Stock Exchange','USA','9:00:00','9:02:00','22:30:00','22:35:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'NASDAQ','National Association of Securities Dealers Automated Quotations','USA','9:00:00','9:02:00','22:30:00','22:35:00'); 
INSERT DBExchange (ID, Exchange,ExchangeName,Country,OpenAuctions,Openning,CloseAuctions,Closing) VALUES (NEWID(), 'NASDAQ OTC','National Association of Securities Dealers Automated Quotations OTC','USA','9:00:00','9:02:00','22:30:00','22:35:00'); 



/* MAJORS CURRECNIES*/
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Europe','European euro','EUR',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'United States of America','United States dollar','USD',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'United Kingdom','British pound','GBP',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Switzerland','Swiss franc','CHF',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Hong Kong','Hong Kong Dollars','HKD',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Japan','Japanese yen','JPY',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Australia','Australian dollar','AUD',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Canada','Canadian dollar','CAD',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Mexico','Mexican peso','MXN',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Norway','Norwegian krone','NOK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'New Zealand','New Zealand dollar','NZD',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Sweden','Swedish krona','SEK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Singapour','Singapourian Dollars','SGD',1);

INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Israel','Israeli new sheqel','ILS',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Denmark','Danish krone','DKK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Slovak Republic','Slovak Koruna','SKK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Czech Republic','Czech koruna ','CZK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Estonian','Estonian Kroon','EEK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Croatia','Croatian Kuna','HRK',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Hungary','Hungarian Fori','HUF',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'India','Indian Rupee','INR',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Korea','Korean Won','KRW',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Lithuania','Lithuanian Litas  ','LTL',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Malte','Maltese Lira','MTL',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Latvian','Latvian Lats','LVL',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Romania','Romanian Leu','RON',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Russia','Russian Ruble','RUB',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Slovenia','Slovenian Tolar','SIT',1);
INSERT DBCurrency (ID,Country,CurrencyName,Ticker,ReferencePrice) VALUES (NEWID(),'Taiwan','New Taiwan Dollar','TWD',1);